Starting Value
The current value of the sequence.
Increment
To specify which value is added to the current sequence value to create a new value. A positive value will make an ascending sequence, a negative one a descending sequence. The default value is 1.
Minimum Value
The minimum value a sequence can generate.
Maximum Value
The maximum value for the sequence.
Cache Size
To specify how many values of the sequence the database preallocates and keeps in memory for faster access. The minimum value for this parameter is 2. (The database caches 20 sequence numbers by default.)
No cache
This option indicates that values of the sequence are not preallocated.
Cyclic
This option allows the sequence continues to generate values after reaching either its maximum or minimum value. After an ascending sequence reaches its maximum value, it generates its minimum value. After a descending sequence reaches its minimum, it generates its maximum value.
Order
This option guarantees that sequence numbers are generated in order of request.